-
Re: COUNTIFS WITH DISTINCT
Hi Archie Villa, You can try this formula where I have used Count collects functions to find out distinct values in Contain column with respect to warehouse and week. =COUNT(DISTINCT(COLLECT(CONTAIN:…1 · -
Re: Total # of Assigned Projects per Month in from the "Assignment Date" column
Hi Ena, I would suggest that to create one helper column for Months, =IFERROR(MONTH([Assignment Date]@row), ""), I am assuming in the Result column each cell represents each month or you ca…1 · -
Re: I am working on a project truck movement, I want to extract time duration in hours or minutes.
Hi Navneetkaur, In which column you are calculating the Duration in your Project Sheet? I would suggest creating a Separate column and adding hours and minutes and then calculating the time with the …1 ·